oracle 使用listagg函数后 字符串连接的结果过长最终解决

SELECT

r.department_id law_dept_id,

(

SELECT

xmlagg(xmlparse(content rt.extracted_person_ids||',' wellformed) order by rt.extracted_person_ids).getclobval()

FROM

RANDOM_TASK rt,

SYS_DEPARTMENT sd

WHERE

rt.CREAT_DEPARTMENT_ID = sd.DEPARTMENT_ID

AND sd.DEPARTMENT_NUMBER LIKE CONCAT (r.department_num, '%')

AND rt.distributed_state = 1

AND rt.STATE = 1

AND rt.LAUNCH_DATE BETWEEN TO_DATE ('2017-07-05', 'yyyy-mm-dd')

AND (TO_DATE('2017-07-05', 'yyyy-mm-dd') + 1)

) law_user_str

FROM

random_user_count r

ORDER BY

r.area_code,

r.department_num;

上述方法已通过验证。